mstobs@observium:~/observium $ ./discovery.php d --d -m neighbours -h fult-c01d00.ennetwork.mst.edu
DEBUG!
CMD[/usr/bin/svn info /local/mstobs/observium]
CMD EXITCODE[0]
CMD RUNTIME[0.0102s]
STDOUT[
Path: .
Working Copy Root Path: /local/mstobs/observium
URL: http://svn.observium.org/svn/observium/trunk
Relative URL: ^/observium/trunk
Repository Root: http://svn.observium.org/svn
Repository UUID: 61d68cd4-352d-0410-923a-c4978735b2b8
Revision: 8915
Node Kind: directory
Schedule: normal
Last Changed Author: mike
Last Changed Rev: 8915
Last Changed Date: 2017-10-18 12:13:41 -0500 (Wed, 18 Oct 2017)
]
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';]
SQL RUNTIME[0.00016785s]
SQL[SELECT @@SESSION.sql_mode;]
SQL RUNTIME[0.00008202s]
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';]
SQL RUNTIME[0.00010920s]
SQL[SELECT * FROM `config`]
SQL RUNTIME[0.00016594s]
___ _ _
/ _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___
| | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \
| |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | |
\___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_|
Observium Professional 17.10.8915
http://www.observium.org
CMD[/local/mstobs/observium/scripts/distro]
CMD EXITCODE[0]
CMD RUNTIME[0.0448s]
STDOUT[
Linux|4.4.0-89-generic|amd64|Ubuntu|16.04|vmware
]
CMD[/usr/bin/env python --version 2>&1]
CMD EXITCODE[0]
CMD RUNTIME[0.0026s]
STDOUT[
Python 2.7.12
]
SQL[SELECT version();]
SQL RUNTIME[0.01512504s]
CMD[/usr/bin/snmpget --version 2>&1]
CMD EXITCODE[0]
CMD RUNTIME[0.0025s]
STDOUT[
NET-SNMP version: 5.7.3
]
CMD[/usr/bin/rrdtool --version | head -n1]
CMD EXITCODE[0]
CMD RUNTIME[0.0127s]
STDOUT[
RRDtool 1.5.5 Copyright by Tobias Oetiker <tobi@oetiker.ch>
]
CMD[/usr/bin/rrdcached -h | head -n1]
CMD EXITCODE[0]
CMD RUNTIME[0.006s]
STDOUT[
RRDCacheD 1.5.5
]
CMD[/usr/sbin/apache2 -v | awk '/Server version:/ {print $3}']
CMD EXITCODE[0]
CMD RUNTIME[0.026s]
STDOUT[
Apache/2.4.18
]
CMD[date "+%:z"]
CMD EXITCODE[0]
CMD RUNTIME[0.0023s]
STDOUT[
-05:00
]
SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);]
SQL RUNTIME[0.00018287s]
SQL[SELECT @@SESSION.sql_mode;]
SQL RUNTIME[0.00008988s]
SQL[SHOW VARIABLES LIKE 'character_set_connection']
SQL RUNTIME[0.09185505s]
##### Software versions #####
o OS Linux 4.4.0-89-generic [amd64] (Ubuntu 16.04)
o Apache 2.4.18
o PHP 7.0.22-0ubuntu0.16.04.1 (OPcache: DISABLED)
o Python 2.7.12
o MySQL 5.6.36-82.1 (extension: mysqli 5.0.12-dev)
o SNMP NET-SNMP 5.7.3
o RRDtool 1.5.5 (rrdcached 1.5.5: unix:/local/mstobs/rrdcache/rrdcached.sock)
##### Memory Limit #####
o PHP Unlimited
##### MySQL mode #####
o MySQL NO_ENGINE_SUBSTITUTION
##### Charset info #####
o PHP UTF-8
o MySQL utf8
##### Timezones info #####
o Date Thursday, 19-Oct-17 13:24:45 CDT
o PHP -05:00
o MySQL -05:00
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck';]
SQL RUNTIME[0.00015688s]
SQL[SELECT COUNT(*) FROM ports]
SQL RUNTIME[0.03512812s]
SQL[SELECT COUNT(*) FROM devices]
SQL RUNTIME[0.00290489s]
SQL[SELECT COUNT(*) FROM `sensors`]
SQL RUNTIME[0.00496483s]
SQL[SELECT COUNT(*) FROM `services`]
SQL RUNTIME[0.00395989s]
SQL[SELECT COUNT(*) FROM `applications`]
SQL RUNTIME[0.00009584s]
SQL[SELECT COUNT(*) FROM `bgpPeers`]
SQL RUNTIME[0.00009108s]
SQL[SELECT COUNT(*) FROM `ospf_ports`]
SQL RUNTIME[0.00090384s]
SQL[SELECT COUNT(*) FROM `eigrp_ports`]
SQL RUNTIME[0.00008297s]
SQL[SELECT COUNT(*) FROM `ipsec_tunnels`]
SQL RUNTIME[0.00008702s]
SQL[SELECT COUNT(*) FROM `munin_plugins`]
SQL RUNTIME[0.00007415s]
SQL[SELECT COUNT(*) FROM `pseudowires`]
SQL RUNTIME[0.00007987s]
SQL[SELECT COUNT(*) FROM `vrfs`]
SQL RUNTIME[0.00009012s]
SQL[SELECT COUNT(*) FROM `vminfo`]
SQL RUNTIME[0.00008893s]
SQL[SELECT COUNT(*) FROM `users`]
SQL RUNTIME[0.01170802s]
SQL[SELECT COUNT(*) FROM `bills`]
SQL RUNTIME[0.00014591s]
SQL[SELECT COUNT(*) FROM `alert_table`]
SQL RUNTIME[0.01539183s]
SQL[SELECT COUNT(*) FROM `alert_tests`]
SQL RUNTIME[0.00013089s]
SQL[SELECT COUNT(*) FROM `slas`]
SQL RUNTIME[0.00010204s]
SQL[SELECT COUNT(*) FROM `status`]
SQL RUNTIME[0.00211215s]
SQL[SELECT COUNT(*) FROM `groups`]
SQL RUNTIME[0.00876498s]
SQL[SELECT COUNT(*) FROM `group_table`]
SQL RUNTIME[0.00464010s]
SQL[SELECT SUM(`last_polled_timetaken`) FROM devices]
SQL RUNTIME[0.00130105s]
SQL[SELECT SUM(`last_discovered_timetaken`) FROM devices]
SQL RUNTIME[0.00142503s]
CMD[DISTROFORMAT=export /local/mstobs/observium/scripts/distro]
CMD EXITCODE[0]
CMD RUNTIME[0.0089s]
STDOUT[
OS=Linux
KERNEL=4.4.0-89-generic
ARCH=amd64
DISTRO=Ubuntu
VERSION=16.04
VIRT=vmware
SCRIPTVER=1.2.1
]
SQL[SELECT `sysObjectID`, COUNT(*) AS `count` FROM `devices` WHERE `os` = 'generic' GROUP BY `sysObjectID`]
SQL RUNTIME[0.00033689s]
SQL[SELECT COUNT(*) AS `count`, `os` FROM `devices` GROUP BY `os`]
SQL RUNTIME[0.00100517s]
SQL[SELECT COUNT(*) AS `count`, `type` FROM `devices` GROUP BY `type`]
SQL RUNTIME[0.00193691s]
SQL[SELECT COUNT(*) AS `count`, `app_type` FROM `applications` GROUP BY `app_type`]
SQL RUNTIME[0.00013685s]
SQL[SELECT MAX(LENGTH(`port_label`)) FROM `ports`]
SQL RUNTIME[0.07604694s]
SQL[SELECT MAX(LENGTH(`port_label_short`)) FROM `ports`]
SQL RUNTIME[0.05054116s]
SQL[SELECT MAX(LENGTH(`port_label_base`)) FROM `ports`]
SQL RUNTIME[0.05174589s]
SQL[SELECT MAX(LENGTH(`port_label_num`)) FROM `ports`]
SQL RUNTIME[0.04994893s]
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'unique_id';]
SQL RUNTIME[0.00041413s]
REQUEST[http://www.observium.org/versions.php]
REQUEST STATUS[TRUE]
REQUEST RUNTIME[0.7452s]
RESPONSE CODE[200 OK]
SQL[SELECT COUNT(*) FROM `observium_attribs` WHERE `attrib_type` = 'latest_ver';]
SQL RUNTIME[0.00015807s]
SQL[UPDATE `observium_attribs` set `attrib_value` ='17.10.8918' WHERE `attrib_type` = 'latest_ver']
SQL RUNTIME[0.00020409s]
SQL[SELECT COUNT(*) FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';]
SQL RUNTIME[0.00010920s]
SQL[UPDATE `observium_attribs` set `attrib_value` ='8918' WHERE `attrib_type` = 'latest_rev']
SQL RUNTIME[0.00015092s]
SQL[SELECT COUNT(*) FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev_date';]
SQL RUNTIME[0.00012302s]
SQL[UPDATE `observium_attribs` set `attrib_value` ='2017-10-19' WHERE `attrib_type` = 'latest_rev_date']
SQL RUNTIME[0.00013709s]
SQL[SELECT COUNT(*) FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck';]
SQL RUNTIME[0.00010300s]
SQL[UPDATE `observium_attribs` set `attrib_value` ='1508437486' WHERE `attrib_type` = 'last_versioncheck']
SQL RUNTIME[0.00012207s]
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';]
SQL RUNTIME[0.00009513s]
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_ver';]
SQL RUNTIME[0.00010204s]
SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev_date';]
SQL RUNTIME[0.00009894s]
There is a newer revision of Observium available!
Version 17.10.8918 (19th October 2017) is 3 revisions ahead.
##### Starting discovery run at 2017-10-19 13:24:46 #####
SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` LIKE 'fult-c01d00.network.mst.edu' AND `status` = '1' ORDER BY `last_discovered_timetaken` ASC]
SQL RUNTIME[0.01200604s]
CMD[/usr/bin/snmpget -t '3' -v2c -c *** -Pu -OQUst -m SNMPv2-MIB -M /local/mstobs/observium/mibs/rfc:/local/mstobs/observium/mibs/net-snmp 'udp':'fult-c01d00.network.mst.edu':'161' sysObjectID.0 sysUpTime.0]
CMD EXITCODE[0]
CMD RUNTIME[0.0112s]
STDOUT[
sysObjectID.0 = enterprises.9.1.1605
sysUpTime.0 = 398748179
]
SNMP STATUS[TRUE]
SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '211']
SQL RUNTIME[0.00030184s]
SQL[SELECT * FROM `observium_processes` WHERE `process_name` = 'discovery.php' AND `device_id` = '211']
SQL RUNTIME[0.00014997s]
CMD[/bin/ps -ww -o pid,ppid,uid,gid,tty,stat,time,lstart,args -p 12218]
CMD EXITCODE[0]
CMD RUNTIME[0.0146s]
STDOUT[
PID PPID UID GID TT STAT TIME STARTED COMMAND
12218 3256 100072951 100072951 pts/0 S+ 00:00:00 Thu Oct 19 13:24:44 2017 php ./discovery.php -d -m neighbours -h fult-c01d00.network.mst.edu
]
SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`) VALUES ('12218','discovery.php','3256','100072951','php ./discovery.php -d -m neighbours -h fult-c01d00.network.mst.edu','1508437484','211')]
SQL RUNTIME[0.00031805s]
##### fult-c01d00.network.mst.edu [211] #####
o OS Type iosxe
o OS Group cisco
o SNMP Version v2c
o Last discovery 2017-10-19 03:38:48
o Last duration 10.43 seconds
##### Module Start: neighbours #####
SQL[SELECT * FROM `observium_attribs`]
SQL RUNTIME[0.00018811s]
o LLDP-MIB
CMD[/usr/bin/snmpbulkwalk -t '3' -v2c -c *** -Pu -OQUs -m LLDP-MIB -M /local/mstobs/observium/mibs/rfc:/local/mstobs/observium/mibs/net-snmp 'udp':'fult-c01d00.network.mst.edu':'161' lldpRemoteSystemsData]
CMD EXITCODE[0]
CMD RUNTIME[0.0275s]
STDOUT[
lldpRemChassisIdSubtype.0.1.3 = macAddress
lldpRemChassisIdSubtype.0.15.6 = macAddress
lldpRemChassisIdSubtype.0.16.5 = macAddress
lldpRemChassisId.0.1.3 = "00 E1 6D 6A 76 80 "
lldpRemChassisId.0.15.6 = "CC 4E 24 6F C3 00 "
lldpRemChassisId.0.16.5 = "CC 4E 24 6F C3 00 "
lldpRemPortIdSubtype.0.1.3 = interfaceName
lldpRemPortIdSubtype.0.15.6 = macAddress
lldpRemPortIdSubtype.0.16.5 = macAddress
lldpRemPortId.0.1.3 = "Te1/0/2"
lldpRemPortId.0.15.6 = "CC 4E 24 6F C3 24 "
lldpRemPortId.0.16.5 = "60 9C 9F 80 DC A4 "
lldpRemPortDesc.0.1.3 = TenGigabitEthernet1/0/2
lldpRemPortDesc.0.15.6 = 10GigabitEthernet1/1/37
lldpRemPortDesc.0.16.5 = 10GigabitEthernet2/1/37
lldpRemSysName.0.1.3 = FULT-C01DA0.network.mst.edu
lldpRemSysName.0.15.6 = CR01
lldpRemSysName.0.16.5 = CR01
lldpRemSysDesc.0.1.3 = Cisco IOS Software, C2960X Software (C2960X-UNIVERSALK9-M), Version 15.0(2)EX5, RELEASE SOFTWARE (fc1)
Technical Support: http://www.cisco.com/techsupport
Copyright (c) 1986-2014 by Cisco Systems, Inc.
Compiled Fri 21-Feb-14 05:54 by prod_rel_team
lldpRemSysDesc.0.15.6 =
lldpRemSysDesc.0.16.5 =
lldpRemSysCapSupported.0.1.3 = "28 00 "
lldpRemSysCapSupported.0.15.6 = "28 00 "
lldpRemSysCapSupported.0.16.5 = "28 00 "
lldpRemSysCapEnabled.0.1.3 = "20 00 "
lldpRemSysCapEnabled.0.15.6 = "28 00 "
lldpRemSysCapEnabled.0.16.5 = "28 00 "
lldpRemManAddrIfSubtype.0.1.3.ipV4."..C." = systemPortNumber
lldpRemManAddrIfSubtype.0.15.6.ipV4."...N" = ifIndex
lldpRemManAddrIfSubtype.0.16.5.ipV4."...N" = ifIndex
lldpRemManAddrIfId.0.1.3.ipV4."..C." = 200
lldpRemManAddrIfId.0.15.6.ipV4."...N" = 16777526
lldpRemManAddrIfId.0.16.5.ipV4."...N" = 16777526
lldpRemManAddrOID.0.1.3.ipV4."..C." = zeroDotZero
lldpRemManAddrOID.0.15.6.ipV4."...N" = zeroDotZero
lldpRemManAddrOID.0.16.5.ipV4."...N" = zeroDotZero
]
SNMP STATUS[TRUE]
CMD[/usr/bin/snmpbulkwalk -t '3' -v2c -c *** -Pu -OQUs -m BRIDGE-MIB -M /local/mstobs/observium/mibs/rfc:/local/mstobs/observium/mibs/net-snmp 'udp':'fult-c01d00.network.mst.edu':'161' dot1dBasePortIfIndex]
CMD EXITCODE[0]
CMD RUNTIME[0.0229s]
STDOUT[
dot1dBasePortIfIndex.2 = 3
dot1dBasePortIfIndex.3 = 4
dot1dBasePortIfIndex.4 = 5
dot1dBasePortIfIndex.5 = 6
dot1dBasePortIfIndex.6 = 7
dot1dBasePortIfIndex.7 = 8
dot1dBasePortIfIndex.8 = 9
dot1dBasePortIfIndex.9 = 10
dot1dBasePortIfIndex.10 = 11
dot1dBasePortIfIndex.11 = 12
dot1dBasePortIfIndex.12 = 13
dot1dBasePortIfIndex.13 = 14
dot1dBasePortIfIndex.14 = 15
]
SNMP STATUS[TRUE]
CMD[/usr/bin/snmpbulkwalk -t '3' -v2c -c *** -Pu -OQUs -m LLDP-MIB -M /local/mstobs/observium/mibs/rfc:/local/mstobs/observium/mibs/net-snmp 'udp':'fult-c01d00.network.mst.edu':'161' lldpLocPortEntry]
CMD EXITCODE[0]
CMD RUNTIME[0.0243s]
STDOUT[
lldpLocPortIdSubtype.1 = interfaceName
lldpLocPortIdSubtype.2 = interfaceName
lldpLocPortIdSubtype.3 = interfaceName
lldpLocPortIdSubtype.4 = interfaceName
lldpLocPortIdSubtype.5 = interfaceName
lldpLocPortIdSubtype.6 = interfaceName
lldpLocPortIdSubtype.7 = interfaceName
lldpLocPortIdSubtype.8 = interfaceName
lldpLocPortIdSubtype.9 = interfaceName
lldpLocPortIdSubtype.10 = interfaceName
lldpLocPortIdSubtype.11 = interfaceName
lldpLocPortIdSubtype.12 = interfaceName
lldpLocPortIdSubtype.13 = interfaceName
lldpLocPortIdSubtype.14 = interfaceName
lldpLocPortIdSubtype.15 = interfaceName
lldpLocPortIdSubtype.16 = interfaceName
lldpLocPortId.1 = "Te1/1"
lldpLocPortId.2 = "Te1/2"
lldpLocPortId.3 = "Te1/3"
lldpLocPortId.4 = "Te1/4"
lldpLocPortId.5 = "Te1/5"
lldpLocPortId.6 = "Te1/6"
lldpLocPortId.7 = "Te1/7"
lldpLocPortId.8 = "Te1/8"
lldpLocPortId.9 = "Te1/9"
lldpLocPortId.10 = "Te1/10"
lldpLocPortId.11 = "Te1/11"
lldpLocPortId.12 = "Te1/12"
lldpLocPortId.13 = "Te1/13"
lldpLocPortId.14 = "Te1/14"
lldpLocPortId.15 = "Te1/15"
lldpLocPortId.16 = "Te1/16"
lldpLocPortDesc.1 = TenGigabitEthernet1/1
lldpLocPortDesc.2 = TenGigabitEthernet1/2
lldpLocPortDesc.3 = TenGigabitEthernet1/3
lldpLocPortDesc.4 = TenGigabitEthernet1/4
lldpLocPortDesc.5 = TenGigabitEthernet1/5
lldpLocPortDesc.6 = TenGigabitEthernet1/6
lldpLocPortDesc.7 = TenGigabitEthernet1/7
lldpLocPortDesc.8 = TenGigabitEthernet1/8
lldpLocPortDesc.9 = TenGigabitEthernet1/9
lldpLocPortDesc.10 = TenGigabitEthernet1/10
lldpLocPortDesc.11 = TenGigabitEthernet1/11
lldpLocPortDesc.12 = TenGigabitEthernet1/12
lldpLocPortDesc.13 = TenGigabitEthernet1/13
lldpLocPortDesc.14 = TenGigabitEthernet1/14
lldpLocPortDesc.15 = TenGigabitEthernet1/15
lldpLocPortDesc.16 = TenGigabitEthernet1/16
]
SNMP STATUS[TRUE]
SQL[SELECT * FROM `ports` WHERE `device_id` = '211' AND `ifIndex` = '1' AND `ifDescr` NOT LIKE 'Vlan%']
SQL RUNTIME[0.00037408s]
SQL[SELECT `device_id`, `hostname` FROM `devices` WHERE `sysName` = 'FULT-C01DA0.network.mst.edu' OR `hostname` = 'FULT-C01DA0.network.mst.edu']
SQL RUNTIME[0.00028491s]
SQL[SELECT `port_id` FROM `ports` WHERE (`ifName` = 'Te1/0/2' OR `ifDescr` = 'Te1/0/2' OR `port_label_short` = 'Te1/0/2') AND `device_id` = '396']
SQL RUNTIME[0.00029802s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '13335']
SQL RUNTIME[0.00019383s]
SQL[SELECT * FROM `devices` WHERE `device_id` = '211']
SQL RUNTIME[0.00017190s]
SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '211']
SQL RUNTIME[0.00020313s]
Discover neighbour: 211 -> lldp, 13335, 24744, fult-c01da0.network.mst.edu, Te1/0/2, , Cisco IOS Software, C2960X Software (C2960X-UNIVERSALK9-M), Version 15.0(2)EX5, RELEASE SOFTWARE (fc1) Technical Support: http://www.cisco.com/techsupport Copyright (c) 1986-2014 by Cisco Systems, Inc. Compiled Fri 21-Feb-14 05:54 by prod_rel_team,
SQL[SELECT * FROM `neighbours` WHERE `port_id` = '13335' AND `protocol` = 'lldp' AND `remote_hostname` = 'fult-c01da0.network.mst.edu' AND `remote_port` = 'Te1/0/2']
SQL RUNTIME[0.00468683s]
SQL[UPDATE `neighbours` set `remote_hostname` ='fult-c01da0.network.mst.edu' WHERE `neighbour_id` = '2657']
SQL RUNTIME[0.00018406s]
SQL[SELECT * FROM `ports` WHERE `device_id` = '211' AND `ifIndex` = '15' AND `ifDescr` NOT LIKE 'Vlan%']
SQL RUNTIME[0.00022197s]
SQL[SELECT `device_id`, `hostname` FROM `devices` WHERE `sysName` = 'CR01' OR `hostname` = 'CR01']
SQL RUNTIME[0.00020409s]
SQL[SELECT `port_id` FROM `ports` WHERE `ifPhysAddress` = 'cc4e246fc324' AND `device_id` = '301']
SQL RUNTIME[0.00157809s]
SQL[SELECT `port_id` FROM `ports` WHERE (`ifIndex`= 'CC 4E 24 6F C3 24' OR `ifDescr` = '10GigabitEthernet1/1/37') AND `device_id` = '301']
SQL RUNTIME[0.00129414s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '13349']
SQL RUNTIME[0.00021601s]
Discover neighbour: 211 -> lldp, 13349, 18741, cr01.network.mst.edu, CC 4E 24 6F C3 24, , ,
SQL[SELECT * FROM `neighbours` WHERE `port_id` = '13349' AND `protocol` = 'lldp' AND `remote_hostname` = 'cr01.network.mst.edu' AND `remote_port` = 'CC 4E 24 6F C3 24']
SQL RUNTIME[0.00476909s]
SQL[INSERT INTO `neighbours` (`port_id`,`protocol`,`remote_port_id`,`remote_hostname`,`remote_port`,`remote_platform`,`remote_version`,`remote_address`) VALUES ('13349','lldp','18741','cr01.network.mst.edu','CC 4E 24 6F C3 24',NULL,NULL,NULL)]
SQL RUNTIME[0.00587487s]
SQL[SELECT * FROM `ports` WHERE `device_id` = '211' AND `ifIndex` = '16' AND `ifDescr` NOT LIKE 'Vlan%']
SQL RUNTIME[0.00028706s]
SQL[SELECT `device_id`, `hostname` FROM `devices` WHERE `sysName` = 'CR01' OR `hostname` = 'CR01']
SQL RUNTIME[0.00027800s]
SQL[SELECT `port_id` FROM `ports` WHERE `ifPhysAddress` = '609c9f80dca4' AND `device_id` = '301']
SQL RUNTIME[0.00138903s]
SQL[SELECT `port_id` FROM `ports` WHERE (`ifIndex`= '60 9C 9F 80 DC A4' OR `ifDescr` = '10GigabitEthernet2/1/37') AND `device_id` = '301']
SQL RUNTIME[0.00129700s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '13350']
SQL RUNTIME[0.00019407s]
Discover neighbour: 211 -> lldp, 13350, 18796, cr01.network.mst.edu, 60 9C 9F 80 DC A4, , ,
SQL[SELECT * FROM `neighbours` WHERE `port_id` = '13350' AND `protocol` = 'lldp' AND `remote_hostname` = 'cr01.network.mst.edu' AND `remote_port` = '60 9C 9F 80 DC A4']
SQL RUNTIME[0.00017095s]
SQL[INSERT INTO `neighbours` (`port_id`,`protocol`,`remote_port_id`,`remote_hostname`,`remote_port`,`remote_platform`,`remote_version`,`remote_address`) VALUES ('13350','lldp','18796','cr01.network.mst.edu','60 9C 9F 80 DC A4',NULL,NULL,NULL)]
SQL RUNTIME[0.00016308s]
o CISCO-CDP-MIB
CMD[/usr/bin/snmpbulkwalk -t '3' -v2c -c *** -Pu -OQUs -m CISCO-CDP-MIB -M /local/mstobs/observium/mibs/rfc:/local/mstobs/observium/mibs/net-snmp:/local/mstobs/observium/mibs/cisco 'udp':'fult-c01d00.network.mst.edu':'161' cdpCache]
CMD EXITCODE[0]
CMD RUNTIME[0.0335s]
STDOUT[
cdpCacheAddressType.2.1 = ip
cdpCacheAddress.2.1 = "AC 11 43 88 "
cdpCacheVersion.2.1 = Cisco IOS Software, C2960X Software (C2960X-UNIVERSALK9-M), Version 15.0(2)EX5, RELEASE SOFTWARE (fc1)
Technical Support: http://www.cisco.com/techsupport
Copyright (c) 1986-2014 by Cisco Systems, Inc.
Compiled Fri 21-Feb-14 05:54 by prod_rel_team
cdpCacheDeviceId.2.1 = FULT-C01DA0.network.mst.edu
cdpCacheDevicePort.2.1 = TenGigabitEthernet1/0/2
cdpCachePlatform.2.1 = cisco WS-C2960X-48FPD-L
cdpCacheCapabilities.2.1 = "00 00 00 28 "
cdpCacheVTPMgmtDomain.2.1 =
cdpCacheNativeVLAN.2.1 = 1
cdpCacheDuplex.2.1 = fullduplex
cdpCacheLastChange.2.1 = 461:12:39:33.68
]
SNMP STATUS[TRUE]
SQL[SELECT * FROM `ports` WHERE `device_id` = '211' AND `ifIndex` = '2']
SQL RUNTIME[0.00033903s]
SQL[SELECT `device_id` FROM `devices` WHERE `sysName` = 'FULT-C01DA0.network.mst.edu' OR `hostname` = 'FULT-C01DA0.network.mst.edu']
SQL RUNTIME[0.00026011s]
SQL[SELECT `port_id` FROM `ports` WHERE (`ifDescr` = 'TenGigabitEthernet1/0/2' OR `ifName` = 'TenGigabitEthernet1/0/2') AND `device_id` = '396']
SQL RUNTIME[0.00031900s]
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '13336']
SQL RUNTIME[0.00021386s]
Discover neighbour: 211 -> cdp, 13336, 24744, FULT-C01DA0.network.mst.edu, TenGigabitEthernet1/0/2, cisco WS-C2960X-48FPD-L, Cisco IOS Software, C2960X Software (C2960X-UNIVERSALK9-M), Version 15.0(2)EX5, RELEASE SOFTWARE (fc1), 172.17.67.136
SQL[SELECT * FROM `neighbours` WHERE `port_id` = '13336' AND `protocol` = 'cdp' AND `remote_hostname` = 'FULT-C01DA0.network.mst.edu' AND `remote_port` = 'TenGigabitEthernet1/0/2']
SQL RUNTIME[0.00018811s]
o OSPF-MIB
SQL[SELECT * FROM `neighbours` LEFT JOIN `ports` USING(`port_id`) WHERE `device_id` = '211']
SQL RUNTIME[0.00089288s]
13335 -> fult-c01da0.network.mst.edu -> Te1/0/2
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '24744']
SQL RUNTIME[0.00022101s]
SQL[SELECT * FROM `devices` WHERE `device_id` = '396']
SQL RUNTIME[0.00019407s]
SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '396']
SQL RUNTIME[0.00025296s]
13336 -> FULT-C01DA0.network.mst.edu -> TenGigabitEthernet1/0/2
13349 -> CR01 -> CC 4E 24 6F C3 24
SQL[DELETE FROM `neighbours` WHERE `neighbour_id` = '8358']
SQL RUNTIME[0.00017405s]
13349 -> cr01.network.mst.edu -> CC 4E 24 6F C3 24
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '18741']
SQL RUNTIME[0.00020790s]
SQL[SELECT * FROM `devices` WHERE `device_id` = '301']
SQL RUNTIME[0.00015998s]
SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '301']
SQL RUNTIME[0.00028205s]
13350 -> CR01 -> 60 9C 9F 80 DC A4
SQL[DELETE FROM `neighbours` WHERE `neighbour_id` = '8359']
SQL RUNTIME[0.00023818s]
13350 -> cr01.network.mst.edu -> 60 9C 9F 80 DC A4
SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '18796']
SQL RUNTIME[0.00025511s]
+----------+----------------------+----------------------+----------------------+----------------------+----------------------+
| Protocol | ifName | Remote: hostname | port | platform | version |
+----------+----------------------+----------------------+----------------------+----------------------+----------------------+
| LLDP | FastEthernet1 | fult-c01da0.network. | TenGigabitEthernet1/ | ... | Cisco IOS Software, |
| | | mst.edu | 0/2 | | C2960X Software (... |
| CDP | TenGigabitEthernet1/ | FULT-C01DA0.network. | TenGigabitEthernet1/ | cisco WS-C2960X-4... | Cisco IOS Software, |
| | 1 | mst.edu | 0/2 | | C2960X Software (... |
| LLDP | TenGigabitEthernet1/ | cr01.network.mst.edu | 10GigabitEthernet1/1 | ... | ... |
| | 14 | | /37 | | |
| LLDP | TenGigabitEthernet1/ | cr01.network.mst.edu | 10GigabitEthernet2/1 | ... | ... |
| | 15 | | /37 | | |
+----------+----------------------+----------------------+----------------------+----------------------+----------------------+
> $valid[$module] /local/mstobs/observium/includes/discovery/neighbours.inc.php:54
array(
[13335] => array(
[fult-c01da0.network.mst.edu] => array(
[Te1/0/2] => int(1)
)
)
[13349] => array(
[cr01.network.mst.edu] => array(
[CC 4E 24 6F C3 24] => int(1)
)
)
[13350] => array(
[cr01.network.mst.edu] => array(
[60 9C 9F 80 DC A4] => int(1)
)
)
[13336] => array(
[FULT-C01DA0.network.mst.edu] => array(
[TenGigabitEthernet1/0/2] => int(1)
)
)
)
o Changes 2 added, 1 updated, 2 deleted, 1 unchanged
o Duration 0.2192s
SQL[INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`) VALUES ('211','211','device',NOW(),'6','Neighbours: 2 added, 1 updated, 2 deleted, 1 unchanged.')]
SQL RUNTIME[0.00525093s]
SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='network',`last_discovered_timetaken` ='0.241',`force_discovery` ='0' WHERE `device_id` = '211']
SQL RUNTIME[0.00027800s]
SQL[INSERT INTO `devices_perftimes` (`device_id`,`operation`,`start`,`duration`) VALUES ('211','discover','1508437486.3682','0.24190592765808')]
SQL RUNTIME[0.00013089s]
##### fult-c01d00.network.mst.edu [211] completed discovery modules at 2017-10-19 13:24:46 #####
o Discovery time 0.241 seconds
SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '12218' AND `process_name` = 'discovery.php' AND `device_id` = '211']
SQL RUNTIME[0.00016904s]
##### Finished discovery run at 2017-10-19 13:24:46 #####
SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`) VALUES ('discover','fult-c01d00.network.mst.edu','1508437485.0348','1.576','1')]
SQL RUNTIME[0.00647306s]
./discovery.php: fult-c01d00.network.mst.edu - 1 devices discovered in 1.576 secs
SQL[SELECT * FROM `observium_processes` WHERE `process_start` < '1508423085']
SQL RUNTIME[0.00019598s]
NOTE, $config['snmp']['hide_auth'] is set to TRUE, snmp community and snmp v3 auth hidden from debug output.
o Devices Discovered 1
o Discovery Time 1.576 secs
o Memory usage 12MB (peak: 14MB)
o MySQL Usage Cell[42/0.349s] Row[28/0.018s] Rows[15/0.112s] Column[0/0s] Update[6/0.002s] Insert[6/0.019s] Delete[3/0.001s]
o RRDTool Usage
mstobs@observium:~/observium $ logout
Connection to observium closed.
[netstat]netconf $logout